/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 80012
 Source Host           : localhost:3306
 Source Schema         : datc

 Target Server Type    : MySQL
 Target Server Version : 80012
 File Encoding         : 65001

 Date: 28/08/2018 10:42:28
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for datc_admin
-- ----------------------------
DROP TABLE IF EXISTS `datc_admins`;
CREATE TABLE `datc_admins` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of datc_admin
-- ----------------------------
BEGIN;
INSERT INTO `datc_admins` VALUES (1, 'jiahao', '$2y$10$cYoihtXKTTbHbrjbiyjCFuNwx5m0YiPClU0lQgnO2KQ6g7rzHAB06', 'j6fBKNshlqySlhCgSXQTa9pXfjvWlA09rZpsK01z4KMS7AZP6ni0x0wUePZ2', '2018-08-27 03:04:08', '2018-08-27 03:04:08');
INSERT INTO `datc_admins` VALUES (2, 'wanghao', '$2y$10$2S3mFWca7vwPWw0.1y.ok.MHPItfQLEBj4lbeqjgn18oXDs.ggmQi', NULL, '2018-08-27 03:15:06', '2018-08-27 03:15:06');
COMMIT;

-- ----------------------------
-- Table structure for datc_admin_role
-- ----------------------------
DROP TABLE IF EXISTS `datc_admin_roles`;
CREATE TABLE `datc_admin_roles` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- Table structure for datc_banner
-- ----------------------------
DROP TABLE IF EXISTS `datc_banners`;
CREATE TABLE `datc_banners` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `picture` varchar(255) NOT NULL COMMENT '路径',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '标题',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0系统1商城',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of datc_banner
-- ----------------------------
BEGIN;
INSERT INTO `datc_banners` VALUES (7, '/uploads/2018-08-25/ts_1535166999186469.png', '2018-08-25 11:16:39', '2018-08-25 11:16:39', '美女生活照', 0);
INSERT INTO `datc_banners` VALUES (8, '/uploads/2018-08-25/ts_1535167009373424.png', '2018-08-25 11:16:49', '2018-08-25 11:16:49', '美女生活照', 0);
INSERT INTO `datc_banners` VALUES (9, '/uploads/2018-08-25/ts_1535167022216702.png', '2018-08-25 11:17:02', '2018-08-25 11:17:02', '美女生活照', 0);
COMMIT;


-- ----------------------------
-- Table structure for datc_menu
-- ----------------------------
DROP TABLE IF EXISTS `datc_menus`;
CREATE TABLE `datc_menus` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(255) DEFAULT NULL,
  `pid` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for datc_menu_role
-- ----------------------------
DROP TABLE IF EXISTS `datc_menu_roles`;
CREATE TABLE `datc_menu_roles` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- ----------------------------
-- Table structure for datc_role
-- ----------------------------
DROP TABLE IF EXISTS `datc_roles`;
CREATE TABLE `datc_roles` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

